# -*- coding:UTF-8 -*-
import re
import sys

import pymysql
import requests
from bs4 import BeautifulSoup

"""
类说明:获取财务数据

Author:
	Jack Cui
Blog:
	http://blog.csdn.net/c406495762
Zhihu:
	https://www.zhihu.com/people/Jack--Cui/
Modify:
	2017-08-31
"""


class FinancialData():

	def __init__(self):
		# 服务器域名
		self.server = 'http://quotes.money.163.com/'
		# self.cwnb = 'http://quotes.money.163.com/hkstock/'

		# 财务数据  http://quotes.money.163.com/hkstock/cwsj_00395.html
		self.cwnb = 'http://quotes.money.163.com/hkstock/cwsj_'

		### 具体表格的展示请看 http://quotes.money.163.com/hkstock/cwsj_00395.html
		# 主要财务指标
		self.cwzb_dict = {'EPS': '基本每股收益', 'EPS_DILUTED': '摊薄每股收益', 'GROSS_MARGIN': '毛利率',
						  'CAPITAL_ADEQUACY': '资本充足率', 'LOANS_DEPOSITS': '贷款回报率', 'ROTA': '总资产收益率',
						  'ROEQUITY': '净资产收益率', 'CURRENT_RATIO': '流动比率', 'QUICK_RATIO': '速动比率',
						  'ROLOANS': '存贷比', 'INVENTORY_TURNOVER': '存货周转率', 'GENERAL_ADMIN_RATIO': '管理费用比率',
						  'TOTAL_ASSET2TURNOVER': '资产周转率', 'FINCOSTS_GROSSPROFIT': '财务费用比率', 'TURNOVER_CASH': '销售现金比率',
						  'YEAREND_DATE': '报表日期'}
		# 利润表
		self.lrb_dict = {'TURNOVER': '总营收', 'OPER_PROFIT': '经营利润', 'PBT': '除税前利润',
						 'NET_PROF': '净利润', 'EPS': '每股基本盈利', 'DPS': '每股派息',
						 'INCOME_INTEREST': '利息收益', 'INCOME_NETTRADING': '交易收益', 'INCOME_NETFEE': '费用收益',
						 'YEAREND_DATE': '报表日期'}
		# 资产负债表
		self.fzb_dict = {
			'FIX_ASS': '固定资产', 'CURR_ASS': '流动资产', 'CURR_LIAB': '流动负债',
			'INVENTORY': '存款', 'CASH': '现金及银行存结', 'OTHER_ASS': '其他资产',
			'TOTAL_ASS': '总资产', 'TOTAL_LIAB': '总负债', 'EQUITY': '股东权益',
			'CASH_SHORTTERMFUND': '库存现金及短期资金', 'DEPOSITS_FROM_CUSTOMER': '客户存款',
			'FINANCIALASSET_SALE': '可供出售之证券', 'LOAN_TO_BANK': '银行同业存款及贷款',
			'DERIVATIVES_LIABILITIES': '金融负债', 'DERIVATIVES_ASSET': '金融资产', 'YEAREND_DATE': '报表日期'}
		# 现金流表
		self.llb_dict = {
			'CF_NCF_OPERACT': '经营活动产生的现金流', 'CF_INT_REC': '已收利息', 'CF_INT_PAID': '已付利息',
			'CF_DIV_REC': '已收股息', 'CF_DIV_PAID': '已派股息', 'CF_INV': '投资活动产生现金流',
			'CF_FIN_ACT': '融资活动产生现金流', 'CF_BEG': '期初现金及现金等价物', 'CF_CHANGE_CSH': '现金及现金等价物净增加额',
			'CF_END': '期末现金及现金等价物', 'CF_EXCH': '汇率变动影响', 'YEAREND_DATE': '报表日期'}
		# 总表
		self.table_name2e = {'主要财务指标 ':'cwzb', '利润表':'lrb', '资产负债表':'fzb', '现金流量表 ':'llb'}
		# 主要财务指标		利润表		资产负债表		现金流量表
		self.table_dict = {'cwzb': self.cwzb_dict, 'lrb': self.lrb_dict, 'fzb': self.fzb_dict, 'llb': self.llb_dict}
		# 请求头
		self.headers = {
			'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8',
			'Accept-Encoding': 'gzip, deflate',
			'Accept-Language': 'zh-CN,zh;q=0.8',
			'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.109 Safari/537.36'}

	"""
	函数说明:获取股票页面信息

	Author:
		Jack Cui
	Parameters:
	    url - 股票财务数据界面地址
	Returns:
	    name - 股票名
	    table_name_list - 财务报表名称
	    table_date_list - 财务报表年限
	    url_list - 财务报表查询连接
	Blog:
		http://blog.csdn.net/c406495762
	Zhihu:
		https://www.zhihu.com/people/Jack--Cui/
	Modify:
		2017-08-31
	"""

	def get_informations(self, url):
		req = requests.get(url=url, headers=self.headers)
		req.encoding = 'utf-8'
		html = req.text
		page_bf = BeautifulSoup(html, 'lxml')
		# 股票名称，股票代码
		name = page_bf.find_all('span', class_='name')[0].string
		# code = page_bf.find_all('span', class_ = 'code')[0].string
		# code = re.findall('\d+',code)[0]

		# 存储各个表名的列表
		table_name_list = []
		table_date_list = []
		each_date_list = []
		url_list = []

		'''
		表名和表时间
			主要财务指标 
			利润表
			资产负债表
			现金流量表 
		'''
		table_name = page_bf.find_all('div', class_='titlebar3')
		for each_table_name in table_name:
			# 表名
			table_name_list.append(each_table_name.span.string)
			# 表时间
			for each_table_date in each_table_name.div.find_all('select', id=re.compile('.+1$')):
				url_list.append(re.findall('(\w+)1', each_table_date.get('id'))[0]) # 选择每个时间表格的id
				for each_date in each_table_date.find_all('option'):  # 选择所有时间
					each_date_list.append(each_date.string)
				table_date_list.append(each_date_list)
				each_date_list = []

		print('*'*100)
		print('table_name_list', table_name_list)
		print('table_date_list', table_date_list)
		print('url_list', url_list)
		print('*'*100)

		return name, table_name_list, table_date_list, url_list

	"""
	函数说明:财务报表入库

	Author:
		Jack Cui
	Parameters:
	    name - 股票名
	    table_name_list - 财务报表名称
	    table_date_list - 财务报表年限
	    url_list - 财务报表查询连接
	Returns:
		无
	Blog:
		http://blog.csdn.net/c406495762
	Zhihu:
		https://www.zhihu.com/people/Jack--Cui/
	Modify:
		2017-08-31
	"""

	def insert_tables(self, name, table_name_list, table_date_list, url_list):
		# 打开数据库连接:host-连接主机地址,port-端口号,user-用户名,passwd-用户密码,db-数据库名,charset-编码
		conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='root', db='financialdata',
							   charset='utf8')
		# 使用cursor()方法获取操作游标
		cursor = conn.cursor()
		# 插入信息
		for i in range(len(table_name_list)):
			sys.stdout.write('    [正在下载       ]    %s' % table_name_list[i] + '\r')
			# 获取数据地址
			url = self.server + 'hk/service/cwsj_service.php?' \
								'symbol={}&' \
								'start={}&' \
								'end={}&' \
								'type={}&' \
								'unit=yuan'.format(
				code,
				table_date_list[i][-1],
				table_date_list[i][0],
				url_list[i]
			)
			req_table = requests.get(url=url, headers=self.headers)
			table = req_table.json()

			print(table_name_list[i])
			print(table)

			nums = len(table)
			value_dict = {}
			for num in range(nums):
				sys.stdout.write('    [正在下载 %.2f%%]   ' % (((num + 1) / nums) * 100) + '\r')
				sys.stdout.flush()
				# value_dict['股票名'] = name
				# value_dict['股票代码'] = code
				# for key, value in table[num].items():
				# 	if key in self.table_dict[url_list[i]]:
				# 		value_dict[self.table_dict[url_list[i]][key]] = value
				print(type(str(table_name_list[i])))
				print(str(table_name_list[i]))
				print(table_name_list[i], type(table_name_list[i]))
				print(table_name_list[int(i)], type(table_name_list[int(i)]))
				print(self.table_name2e.get(table_name_list[i]))
				self.main_table = self.table_dict.get(self.table_name2e.get(table_name_list[int(i)]))

				main_sql = "INSERT INTO {} ( ".format(self.table_name2e.get(table_name_list[i]))
				for i in self.main_table.keys():
					main_sql += " `{}`, ".format(i)
				main_sql += " ) VALUES ( "
				for i in self.main_table:
					main_sql += " '%s', "
				main_sql += " )"

				table_value = list()
				for i in table[num].values():
					table_value.append(i)

				table_value = tuple(table_value)

				main_sql = main_sql % table_value

				print(main_sql)

				#
				# sql1 = """INSERT INTO %s (`股票名`,`股票代码`,`报表日期`) VALUES ('%s','%s','%s')""" % (
				# 	url_list[i], value_dict['股票名'], value_dict['股票代码'], value_dict['报表日期'])
				# print(sql1)
				# try:
				# 	cursor.execute(sql1)
				# 	# 执行sql语句
				# 	conn.commit()
				# except Exception as e:
				# 	print(e)
				# 	# 发生错误时回滚
				# 	conn.rollback()
				#
				# for key, value in value_dict.items():
				# 	if key not in ['股票名', '股票代码', '报表日期']:
				# 		sql2 = """UPDATE %s SET %s='%s' WHERE `股票名`='%s' AND `报表日期`='%s'""" % (
				# 			url_list[i], key, value, value_dict['股票名'], value_dict['报表日期'])
				# 		print(sql2)
				# 		try:
				# 			cursor.execute(sql2)
				# 			# 执行sql语句
				# 			conn.commit()
				# 		except Exception as e:
				# 			print(e)
				# 			# 发生错误时回滚
				# 			conn.rollback()
				# value_dict = {}
			print('    [下载完成 ')

		# 关闭数据库连接
		cursor.close()
		conn.close()


if __name__ == '__main__':
	print('*' * 100)
	print('\t\t\t\t\t财务数据下载助手\n')
	print('作者:Jack-Cui\n')
	print('About Me:\n')
	print('  知乎:https://www.zhihu.com/people/Jack--Cui')
	print('  Blog:http://blog.csdn.net/c406495762')
	print('  Gihub:https://github.com/Jack-Cherish\n')
	print('*' * 100)
	fd = FinancialData()
	# 上市股票地址
	code = input('请输入股票代码:') or '00395'

	name, table_name_list, table_date_list, url_list = fd.get_informations(fd.cwnb + code + '.html')
	print('\n  %s:(%s)财务数据下载中！\n' % (name, code))
	fd.insert_tables(name, table_name_list, table_date_list, url_list)
	print('\n  %s:(%s)财务数据下载完成！' % (name, code))

	'''
	请输入股票代码:00395

  中国智能集团:(00395)财务数据下载中！

[{'YEAREND_DATE': '2016-12-31', 'EPS': '-0.04', 'EPS_DILUTED': '-0.04', 'GROSS_MARGIN': '39.73%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.30', 'QUICK_RATIO': '1.29', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.10', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '18.16', 'GENERAL_ADMIN_RATIO': '72.08%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.24%'}, {'YEAREND_DATE': '2016-06-30', 'EPS': '-0.01', 'EPS_DILUTED': '-0.01', 'GROSS_MARGIN': '32.34%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '3.32', 'QUICK_RATIO': '3.17', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.05', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '5.62', 'GENERAL_ADMIN_RATIO': '92.27%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.37%'}, {'YEAREND_DATE': '2015-12-31', 'EPS': '-0.04', 'EPS_DILUTED': '-0.04', 'GROSS_MARGIN': '19.40%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '2.43', 'QUICK_RATIO': '2.39', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.29', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '32.61', 'GENERAL_ADMIN_RATIO': '91.92%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.90%'}, {'YEAREND_DATE': '2015-06-30', 'EPS': '-0.02', 'EPS_DILUTED': '-0.02', 'GROSS_MARGIN': '27.04%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.37', 'QUICK_RATIO': '1.26', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.08', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '3.61', 'GENERAL_ADMIN_RATIO': '72.41%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.27%'}, {'YEAREND_DATE': '2014-12-31', 'EPS': '-0.07', 'EPS_DILUTED': '-0.07', 'GROSS_MARGIN': '25.65%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.23', 'QUICK_RATIO': '1.09', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.21', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '4.04', 'GENERAL_ADMIN_RATIO': '51.37%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '1.20%'}, {'YEAREND_DATE': '2014-06-30', 'EPS': '-0.01', 'EPS_DILUTED': '-0.01', 'GROSS_MARGIN': '29.38%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.02', 'QUICK_RATIO': '0.98', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.04', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '3.07', 'GENERAL_ADMIN_RATIO': '96.31%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '1.26%'}, {'YEAREND_DATE': '2013-12-31', 'EPS': '-0.11', 'EPS_DILUTED': '-0.11', 'GROSS_MARGIN': '11.20%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.03', 'QUICK_RATIO': '0.99', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.09', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '3.18', 'GENERAL_ADMIN_RATIO': '95.49%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.32%'}, {'YEAREND_DATE': '2013-06-30', 'EPS': '-0.01', 'EPS_DILUTED': '-0.01', 'GROSS_MARGIN': '4.53%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.04', 'QUICK_RATIO': '1.01', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.03', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '2.36', 'GENERAL_ADMIN_RATIO': '89.11%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.12%'}, {'YEAREND_DATE': '2012-12-31', 'EPS': '-0.10', 'EPS_DILUTED': '-0.10', 'GROSS_MARGIN': '0.00%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.06', 'QUICK_RATIO': '1.01', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.11', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '3.61', 'GENERAL_ADMIN_RATIO': '87.02%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.32%'}, {'YEAREND_DATE': '2012-06-30', 'EPS': '-0.01', 'EPS_DILUTED': '-0.01', 'GROSS_MARGIN': '1.47%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.07', 'QUICK_RATIO': '1.05', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.05', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '6.91', 'GENERAL_ADMIN_RATIO': '81.79%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.19%'}, {'YEAREND_DATE': '2011-12-31', 'EPS': '-0.12', 'EPS_DILUTED': '-0.13', 'GROSS_MARGIN': '17.32%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '1.12', 'QUICK_RATIO': '1.07', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.17', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '6.89', 'GENERAL_ADMIN_RATIO': '83.54%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.67%'}, {'YEAREND_DATE': '2011-06-30', 'EPS': '0.01', 'EPS_DILUTED': '0.01', 'GROSS_MARGIN': '22.15%', 'ROLOANS': '--', 'ROTA': '2.27%', 'ROEQUITY': '4.05%', 'CURRENT_RATIO': '1.18', 'QUICK_RATIO': '1.11', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.09', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '6.21', 'GENERAL_ADMIN_RATIO': '89.23%', 'FINCOSTS_GROSSPROFIT': '22.49%', 'TURNOVER_CASH': '0.57%'}, {'YEAREND_DATE': '2010-12-31', 'EPS': '-0.10', 'EPS_DILUTED': '-0.10', 'GROSS_MARGIN': '8.39%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '4.33', 'QUICK_RATIO': '3.98', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.25', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '5.18', 'GENERAL_ADMIN_RATIO': '84.33%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.55%'}, {'YEAREND_DATE': '2010-06-30', 'EPS': '-0.00', 'EPS_DILUTED': '-0.00', 'GROSS_MARGIN': '10.70%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '3.98', 'QUICK_RATIO': '3.57', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.12', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '4.83', 'GENERAL_ADMIN_RATIO': '78.10%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.33%'}, {'YEAREND_DATE': '2009-12-31', 'EPS': '-0.23', 'EPS_DILUTED': '-0.23', 'GROSS_MARGIN': '0.00%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '4.12', 'QUICK_RATIO': '3.69', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.22', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '4.16', 'GENERAL_ADMIN_RATIO': '70.60%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.55%'}, {'YEAREND_DATE': '2009-06-30', 'EPS': '-0.01', 'EPS_DILUTED': '-0.01', 'GROSS_MARGIN': '0.00%', 'ROLOANS': '--', 'ROTA': '0.00%', 'ROEQUITY': '0.00%', 'CURRENT_RATIO': '4.54', 'QUICK_RATIO': '3.80', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.07', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '0.96', 'GENERAL_ADMIN_RATIO': '80.72%', 'FINCOSTS_GROSSPROFIT': '0.00%', 'TURNOVER_CASH': '0.21%'}, {'YEAREND_DATE': '2008-12-31', 'EPS': '0.02', 'EPS_DILUTED': '0.02', 'GROSS_MARGIN': '23.39%', 'ROLOANS': '--', 'ROTA': '3.56%', 'ROEQUITY': '3.99%', 'CURRENT_RATIO': '4.20', 'QUICK_RATIO': '3.67', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.54', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '9.92', 'GENERAL_ADMIN_RATIO': '75.22%', 'FINCOSTS_GROSSPROFIT': '0.69%', 'TURNOVER_CASH': '1.72%'}, {'YEAREND_DATE': '2008-06-30', 'EPS': '0.03', 'EPS_DILUTED': '0.00', 'GROSS_MARGIN': '26.02%', 'ROLOANS': '--', 'ROTA': '4.36%', 'ROEQUITY': '4.91%', 'CURRENT_RATIO': '4.40', 'QUICK_RATIO': '4.18', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.33', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '13.60', 'GENERAL_ADMIN_RATIO': '64.49%', 'FINCOSTS_GROSSPROFIT': '0.28%', 'TURNOVER_CASH': '1.10%'}, {'YEAREND_DATE': '2007-12-31', 'EPS': '0.05', 'EPS_DILUTED': '0.05', 'GROSS_MARGIN': '23.01%', 'ROLOANS': '--', 'ROTA': '7.14%', 'ROEQUITY': '8.02%', 'CURRENT_RATIO': '4.60', 'QUICK_RATIO': '3.92', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.63', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '8.36', 'GENERAL_ADMIN_RATIO': '54.09%', 'FINCOSTS_GROSSPROFIT': '10.84%', 'TURNOVER_CASH': '2.14%'}, {'YEAREND_DATE': '2007-06-30', 'EPS': '0.03', 'EPS_DILUTED': '0.00', 'GROSS_MARGIN': '24.62%', 'ROLOANS': '--', 'ROTA': '4.31%', 'ROEQUITY': '4.98%', 'CURRENT_RATIO': '4.70', 'QUICK_RATIO': '4.14', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.32', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '4.27', 'GENERAL_ADMIN_RATIO': '57.85%', 'FINCOSTS_GROSSPROFIT': '1.26%', 'TURNOVER_CASH': '0.86%'}, {'YEAREND_DATE': '2006-12-31', 'EPS': '0.06', 'EPS_DILUTED': '0.00', 'GROSS_MARGIN': '25.41%', 'ROLOANS': '--', 'ROTA': '8.76%', 'ROEQUITY': '10.76%', 'CURRENT_RATIO': '2.77', 'QUICK_RATIO': '2.34', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.68', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '8.36', 'GENERAL_ADMIN_RATIO': '54.56%', 'FINCOSTS_GROSSPROFIT': '1.55%', 'TURNOVER_CASH': '2.70%'}, {'YEAREND_DATE': '2006-06-30', 'EPS': '0.03', 'EPS_DILUTED': '0.00', 'GROSS_MARGIN': '26.35%', 'ROLOANS': '--', 'ROTA': '5.11%', 'ROEQUITY': '6.38%', 'CURRENT_RATIO': '2.56', 'QUICK_RATIO': '2.06', 'CAPITAL_ADEQUACY': '--', 'TOTAL_ASSET2TURNOVER': '0.35', 'LOANS_DEPOSITS': '--', 'INVENTORY_TURNOVER': '3.51', 'GENERAL_ADMIN_RATIO': '50.02%', 'FINCOSTS_GROSSPROFIT': '0.87%', 'TURNOVER_CASH': '1.26%'}]
[{'YEAREND_DATE': '2016-12-31', 'TURNOVER': '24,319,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-160,398,000.00', 'PBT': '-159,182,000.00', 'NET_PROF': '-146,762,000.00', 'EPS': '-0.04', 'DPS': '0.00'}, {'YEAREND_DATE': '2016-06-30', 'TURNOVER': '11,260,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-24,001,000.00', 'PBT': '-24,453,000.00', 'NET_PROF': '-18,189,000.00', 'EPS': '-0.01', 'DPS': '0.00'}, {'YEAREND_DATE': '2015-12-31', 'TURNOVER': '85,568,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-185,738,000.00', 'PBT': '-141,780,000.00', 'NET_PROF': '-128,058,000.00', 'EPS': '-0.04', 'DPS': '0.00'}, {'YEAREND_DATE': '2015-06-30', 'TURNOVER': '48,922,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-65,622,000.00', 'PBT': '-65,622,000.00', 'NET_PROF': '-51,810,000.00', 'EPS': '-0.02', 'DPS': '0.00'}, {'YEAREND_DATE': '2014-12-31', 'TURNOVER': '111,622,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-156,627,000.00', 'PBT': '-156,627,000.00', 'NET_PROF': '-163,944,000.00', 'EPS': '-0.07', 'DPS': '0.00'}, {'YEAREND_DATE': '2014-06-30', 'TURNOVER': '51,442,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-14,890,000.00', 'PBT': '-14,890,000.00', 'NET_PROF': '-14,838,000.00', 'EPS': '-0.01', 'DPS': '0.00'}, {'YEAREND_DATE': '2013-12-31', 'TURNOVER': '101,669,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-137,406,000.00', 'PBT': '-137,406,000.00', 'NET_PROF': '-206,016,000.00', 'EPS': '-0.11', 'DPS': '0.00'}, {'YEAREND_DATE': '2013-06-30', 'TURNOVER': '47,977,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-9,735,000.00', 'PBT': '-9,735,000.00', 'NET_PROF': '-10,151,000.00', 'EPS': '-0.01', 'DPS': '0.00'}, {'YEAREND_DATE': '2012-12-31', 'TURNOVER': '156,577,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-180,495,000.00', 'PBT': '-180,495,000.00', 'NET_PROF': '-200,362,000.00', 'EPS': '-0.10', 'DPS': '0.00'}, {'YEAREND_DATE': '2012-06-30', 'TURNOVER': '85,860,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-10,621,000.00', 'PBT': '-10,621,000.00', 'NET_PROF': '-10,621,000.00', 'EPS': '-0.01', 'DPS': '0.00'}, {'YEAREND_DATE': '2011-12-31', 'TURNOVER': '223,855,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-238,254,000.00', 'PBT': '-238,254,000.00', 'NET_PROF': '-234,097,000.00', 'EPS': '-0.12', 'DPS': '0.00'}, {'YEAREND_DATE': '2011-06-30', 'TURNOVER': '136,685,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '20,161,000.00', 'PBT': '20,161,000.00', 'NET_PROF': '16,635,000.00', 'EPS': '0.01', 'DPS': '0.00'}, {'YEAREND_DATE': '2010-12-31', 'TURNOVER': '153,234,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-151,033,000.00', 'PBT': '-151,033,000.00', 'NET_PROF': '-144,739,000.00', 'EPS': '-0.10', 'DPS': '0.00'}, {'YEAREND_DATE': '2010-06-30', 'TURNOVER': '74,514,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-4,304,000.00', 'PBT': '-4,304,000.00', 'NET_PROF': '-4,316,000.00', 'EPS': '-0.00', 'DPS': '0.00'}, {'YEAREND_DATE': '2009-12-31', 'TURNOVER': '126,108,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-395,706,000.00', 'PBT': '-395,706,000.00', 'NET_PROF': '-296,430,000.00', 'EPS': '-0.23', 'DPS': '0.00'}, {'YEAREND_DATE': '2009-06-30', 'TURNOVER': '56,146,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '-16,096,000.00', 'PBT': '-16,096,000.00', 'NET_PROF': '-16,005,000.00', 'EPS': '-0.01', 'DPS': '0.00'}, {'YEAREND_DATE': '2008-12-31', 'TURNOVER': '478,775,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '44,835,000.00', 'PBT': '44,835,000.00', 'NET_PROF': '31,287,000.00', 'EPS': '0.02', 'DPS': '0.00'}, {'YEAREND_DATE': '2008-06-30', 'TURNOVER': '292,239,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '53,068,000.00', 'PBT': '53,068,000.00', 'NET_PROF': '38,846,000.00', 'EPS': '0.03', 'DPS': '0.00'}, {'YEAREND_DATE': '2007-12-31', 'TURNOVER': '541,510,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '80,029,000.00', 'PBT': '80,029,000.00', 'NET_PROF': '61,464,000.00', 'EPS': '0.05', 'DPS': '0.01'}, {'YEAREND_DATE': '2007-06-30', 'TURNOVER': '274,954,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '49,940,000.00', 'PBT': '49,940,000.00', 'NET_PROF': '37,153,000.00', 'EPS': '0.03', 'DPS': '0.00'}, {'YEAREND_DATE': '2006-12-31', 'TURNOVER': '446,719,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '77,510,000.00', 'PBT': '77,510,000.00', 'NET_PROF': '57,797,000.00', 'EPS': '0.06', 'DPS': '0.01'}, {'YEAREND_DATE': '2006-06-30', 'TURNOVER': '224,323,000.00', 'INCOME_INTEREST': '--', 'INCOME_NETFEE': '--', 'INCOME_NETTRADING': '--', 'OPER_PROFIT': '44,885,000.00', 'PBT': '44,885,000.00', 'NET_PROF': '32,609,000.00', 'EPS': '0.03', 'DPS': '0.00'}]
[{'YEAREND_DATE': '2016-12-31', 'FIX_ASS': '66,846,000.00', 'CURR_ASS': '133,120,000.00', 'CURR_LIAB': '102,367,000.00', 'INVENTORY': '1,339,000.00', 'CASH': '100,545,000.00', 'OTHER_ASS': '44,615,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '248,061,000.00', 'TOTAL_DEBT': '15,000,000.00', 'TOTAL_LIAB': '110,574,000.00', 'EQUITY': '92,293,000.00'}, {'YEAREND_DATE': '2016-06-30', 'FIX_ASS': '70,587,000.00', 'CURR_ASS': '88,106,000.00', 'CURR_LIAB': '26,519,000.00', 'INVENTORY': '4,006,000.00', 'CASH': '30,044,000.00', 'OTHER_ASS': '72,314,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '232,607,000.00', 'TOTAL_DEBT': '8,000,000.00', 'TOTAL_LIAB': '35,193,000.00', 'EQUITY': '144,441,000.00'}, {'YEAREND_DATE': '2015-12-31', 'FIX_ASS': '64,313,000.00', 'CURR_ASS': '152,358,000.00', 'CURR_LIAB': '62,721,000.00', 'INVENTORY': '2,624,000.00', 'CASH': '95,515,000.00', 'OTHER_ASS': '72,076,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '292,751,000.00', 'TOTAL_DEBT': '17,368,000.00', 'TOTAL_LIAB': '71,395,000.00', 'EQUITY': '162,301,000.00'}, {'YEAREND_DATE': '2015-06-30', 'FIX_ASS': '108,818,000.00', 'CURR_ASS': '347,535,000.00', 'CURR_LIAB': '254,340,000.00', 'INVENTORY': '27,083,000.00', 'CASH': '184,352,000.00', 'OTHER_ASS': '183,015,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '639,368,000.00', 'TOTAL_DEBT': '23,687,000.00', 'TOTAL_LIAB': '272,913,000.00', 'EQUITY': '318,334,000.00'}, {'YEAREND_DATE': '2014-12-31', 'FIX_ASS': '101,848,000.00', 'CURR_ASS': '248,235,000.00', 'CURR_LIAB': '202,523,000.00', 'INVENTORY': '27,647,000.00', 'CASH': '93,119,000.00', 'OTHER_ASS': '188,470,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '538,553,000.00', 'TOTAL_DEBT': '60,380,000.00', 'TOTAL_LIAB': '267,522,000.00', 'EQUITY': '207,214,000.00'}, {'YEAREND_DATE': '2014-06-30', 'FIX_ASS': '101,977,000.00', 'CURR_ASS': '860,209,000.00', 'CURR_LIAB': '845,227,000.00', 'INVENTORY': '33,546,000.00', 'CASH': '40,801,000.00', 'OTHER_ASS': '204,008,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,166,194,000.00', 'TOTAL_DEBT': '88,616,000.00', 'TOTAL_LIAB': '915,055,000.00', 'EQUITY': '221,152,000.00'}, {'YEAREND_DATE': '2013-12-31', 'FIX_ASS': '104,392,000.00', 'CURR_ASS': '781,630,000.00', 'CURR_LIAB': '759,093,000.00', 'INVENTORY': '31,943,000.00', 'CASH': '317,157,000.00', 'OTHER_ASS': '205,551,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,091,573,000.00', 'TOTAL_DEBT': '112,247,000.00', 'TOTAL_LIAB': '823,175,000.00', 'EQUITY': '238,024,000.00'}, {'YEAREND_DATE': '2013-06-30', 'FIX_ASS': '128,525,000.00', 'CURR_ASS': '1,306,890,000.00', 'CURR_LIAB': '1,254,384,000.00', 'INVENTORY': '40,739,000.00', 'CASH': '389,259,000.00', 'OTHER_ASS': '265,211,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,700,626,000.00', 'TOTAL_DEBT': '79,928,000.00', 'TOTAL_LIAB': '1,340,036,000.00', 'EQUITY': '360,594,000.00'}, {'YEAREND_DATE': '2012-12-31', 'FIX_ASS': '131,305,000.00', 'CURR_ASS': '1,039,150,000.00', 'CURR_LIAB': '982,897,000.00', 'INVENTORY': '43,341,000.00', 'CASH': '483,364,000.00', 'OTHER_ASS': '268,766,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,439,221,000.00', 'TOTAL_DEBT': '78,778,000.00', 'TOTAL_LIAB': '1,068,751,000.00', 'EQUITY': '370,472,000.00'}, {'YEAREND_DATE': '2012-06-30', 'FIX_ASS': '195,842,000.00', 'CURR_ASS': '1,013,368,000.00', 'CURR_LIAB': '942,915,000.00', 'INVENTORY': '24,865,000.00', 'CASH': '442,284,000.00', 'OTHER_ASS': '387,184,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,596,394,000.00', 'TOTAL_DEBT': '79,348,000.00', 'TOTAL_LIAB': '1,037,109,000.00', 'EQUITY': '559,286,000.00'}, {'YEAREND_DATE': '2011-12-31', 'FIX_ASS': '199,771,000.00', 'CURR_ASS': '751,383,000.00', 'CURR_LIAB': '672,328,000.00', 'INVENTORY': '32,500,000.00', 'CASH': '334,996,000.00', 'OTHER_ASS': '392,340,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,343,494,000.00', 'TOTAL_DEBT': '55,391,000.00', 'TOTAL_LIAB': '772,967,000.00', 'EQUITY': '570,531,000.00'}, {'YEAREND_DATE': '2011-06-30', 'FIX_ASS': '180,122,000.00', 'CURR_ASS': '724,392,000.00', 'CURR_LIAB': '613,128,000.00', 'INVENTORY': '44,052,000.00', 'CASH': '237,777,000.00', 'OTHER_ASS': '559,361,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '1,463,875,000.00', 'TOTAL_DEBT': '478,437,000.00', 'TOTAL_LIAB': '642,565,000.00', 'EQUITY': '821,309,000.00'}, {'YEAREND_DATE': '2010-12-31', 'FIX_ASS': '69,421,000.00', 'CURR_ASS': '362,334,000.00', 'CURR_LIAB': '83,642,000.00', 'INVENTORY': '29,591,000.00', 'CASH': '276,802,000.00', 'OTHER_ASS': '179,068,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '610,823,000.00', 'TOTAL_DEBT': '0.00', 'TOTAL_LIAB': '83,642,000.00', 'EQUITY': '527,182,000.00'}, {'YEAREND_DATE': '2010-06-30', 'FIX_ASS': '121,153,000.00', 'CURR_ASS': '301,559,000.00', 'CURR_LIAB': '75,850,000.00', 'INVENTORY': '30,867,000.00', 'CASH': '226,108,000.00', 'OTHER_ASS': '194,713,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '617,425,000.00', 'TOTAL_DEBT': '0.00', 'TOTAL_LIAB': '75,850,000.00', 'EQUITY': '541,292,000.00'}, {'YEAREND_DATE': '2009-12-31', 'FIX_ASS': '120,723,000.00', 'CURR_ASS': '293,426,000.00', 'CURR_LIAB': '71,306,000.00', 'INVENTORY': '30,301,000.00', 'CASH': '230,136,000.00', 'OTHER_ASS': '171,853,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '586,002,000.00', 'TOTAL_DEBT': '0.00', 'TOTAL_LIAB': '71,306,000.00', 'EQUITY': '514,437,000.00'}, {'YEAREND_DATE': '2009-06-30', 'FIX_ASS': '380,970,000.00', 'CURR_ASS': '361,367,000.00', 'CURR_LIAB': '79,667,000.00', 'INVENTORY': '58,438,000.00', 'CASH': '268,583,000.00', 'OTHER_ASS': '108,705,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '851,042,000.00', 'TOTAL_DEBT': '0.00', 'TOTAL_LIAB': '80,197,000.00', 'EQUITY': '765,283,000.00'}, {'YEAREND_DATE': '2008-12-31', 'FIX_ASS': '389,124,000.00', 'CURR_ASS': '381,134,000.00', 'CURR_LIAB': '90,821,000.00', 'INVENTORY': '48,263,000.00', 'CASH': '278,403,000.00', 'OTHER_ASS': '109,576,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '879,834,000.00', 'TOTAL_DEBT': '6,832,000.00', 'TOTAL_LIAB': '91,351,000.00', 'EQUITY': '784,624,000.00'}, {'YEAREND_DATE': '2008-06-30', 'FIX_ASS': '352,511,000.00', 'CURR_ASS': '438,950,000.00', 'CURR_LIAB': '99,863,000.00', 'INVENTORY': '21,494,000.00', 'CASH': '265,894,000.00', 'OTHER_ASS': '100,038,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '891,499,000.00', 'TOTAL_DEBT': '10,649,000.00', 'TOTAL_LIAB': '99,863,000.00', 'EQUITY': '791,636,000.00'}, {'YEAREND_DATE': '2007-12-31', 'FIX_ASS': '312,195,000.00', 'CURR_ASS': '434,184,000.00', 'CURR_LIAB': '94,337,000.00', 'INVENTORY': '64,758,000.00', 'CASH': '253,152,000.00', 'OTHER_ASS': '114,722,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '861,101,000.00', 'TOTAL_DEBT': '12,249,000.00', 'TOTAL_LIAB': '94,337,000.00', 'EQUITY': '766,764,000.00'}, {'YEAREND_DATE': '2007-06-30', 'FIX_ASS': '256,508,000.00', 'CURR_ASS': '540,209,000.00', 'CURR_LIAB': '114,975,000.00', 'INVENTORY': '64,451,000.00', 'CASH': '320,734,000.00', 'OTHER_ASS': '64,854,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '861,571,000.00', 'TOTAL_DEBT': '25,375,000.00', 'TOTAL_LIAB': '114,975,000.00', 'EQUITY': '746,596,000.00'}, {'YEAREND_DATE': '2006-12-31', 'FIX_ASS': '251,104,000.00', 'CURR_ASS': '339,956,000.00', 'CURR_LIAB': '122,682,000.00', 'INVENTORY': '53,467,000.00', 'CASH': '165,718,000.00', 'OTHER_ASS': '68,754,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '659,814,000.00', 'TOTAL_DEBT': '26,694,000.00', 'TOTAL_LIAB': '122,682,000.00', 'EQUITY': '537,132,000.00'}, {'YEAREND_DATE': '2006-06-30', 'FIX_ASS': '297,080,000.00', 'CURR_ASS': '324,226,000.00', 'CURR_LIAB': '126,430,000.00', 'INVENTORY': '63,985,000.00', 'CASH': '177,781,000.00', 'OTHER_ASS': '16,312,000.00', 'CASH_SHORTTERMFUND': '--', 'DEPOSITS_FROM_CUSTOMER': '--', 'LOAN_TO_BANK': '--', 'FINANCIALASSET_SALE': '--', 'DERIVATIVES_ASSET': '--', 'DERIVATIVES_LIABILITIES': '--', 'TOTAL_ASS': '637,618,000.00', 'TOTAL_DEBT': '23,758,000.00', 'TOTAL_LIAB': '0.00', 'EQUITY': '511,188,000.00'}]
[{'YEAREND_DATE': '2016-12-31', 'CF_NCF_OPERACT': '-58,318,000.00', 'CF_INT_REC': '31,000.00', 'CF_INT_PAID': '-888,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-8,372,000.00', 'CF_FIN_ACT': '69,825,000.00', 'CF_BEG': '95,515,000.00', 'CF_CHANGE_CSH': '2,278,000.00', 'CF_END': '99,953,000.00', 'CF_EXCH': '2,160,000.00'}, {'YEAREND_DATE': '2016-06-30', 'CF_NCF_OPERACT': '-36,577,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-19,145,000.00', 'CF_FIN_ACT': '-9,889,000.00', 'CF_BEG': '95,515,000.00', 'CF_CHANGE_CSH': '-65,611,000.00', 'CF_END': '30,044,000.00', 'CF_EXCH': '140,000.00'}, {'YEAREND_DATE': '2015-12-31', 'CF_NCF_OPERACT': '-41,443,000.00', 'CF_INT_REC': '17,000.00', 'CF_INT_PAID': '-1,332,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '-194,000.00', 'CF_INV': '-65,864,000.00', 'CF_FIN_ACT': '106,285,000.00', 'CF_BEG': '93,119,000.00', 'CF_CHANGE_CSH': '-2,531,000.00', 'CF_END': '95,515,000.00', 'CF_EXCH': '4,927,000.00'}, {'YEAREND_DATE': '2015-06-30', 'CF_NCF_OPERACT': '-17,021,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-39,881,000.00', 'CF_FIN_ACT': '147,868,000.00', 'CF_BEG': '93,119,000.00', 'CF_CHANGE_CSH': '90,966,000.00', 'CF_END': '184,352,000.00', 'CF_EXCH': '267,000.00'}, {'YEAREND_DATE': '2014-12-31', 'CF_NCF_OPERACT': '-252,277,000.00', 'CF_INT_REC': '359,000.00', 'CF_INT_PAID': '-3,046,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '211,574,000.00', 'CF_FIN_ACT': '105,625,000.00', 'CF_BEG': '32,157,000.00', 'CF_CHANGE_CSH': '62,235,000.00', 'CF_END': '93,119,000.00', 'CF_EXCH': '-1,273,000.00'}, {'YEAREND_DATE': '2014-06-30', 'CF_NCF_OPERACT': '39,472,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-1,371,000.00', 'CF_FIN_ACT': '-28,198,000.00', 'CF_BEG': '32,157,000.00', 'CF_CHANGE_CSH': '9,903,000.00', 'CF_END': '40,801,000.00', 'CF_EXCH': '-1,259,000.00'}, {'YEAREND_DATE': '2013-12-31', 'CF_NCF_OPERACT': '-207,702,000.00', 'CF_INT_REC': '7,969,000.00', 'CF_INT_PAID': '-3,721,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '170,169,000.00', 'CF_FIN_ACT': '45,616,000.00', 'CF_BEG': '20,364,000.00', 'CF_CHANGE_CSH': '12,331,000.00', 'CF_END': '32,157,000.00', 'CF_EXCH': '-538,000.00'}, {'YEAREND_DATE': '2013-06-30', 'CF_NCF_OPERACT': '27,248,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '2,999,000.00', 'CF_FIN_ACT': '-3,634,000.00', 'CF_BEG': '20,364,000.00', 'CF_CHANGE_CSH': '26,613,000.00', 'CF_END': '46,259,000.00', 'CF_EXCH': '-718,000.00'}, {'YEAREND_DATE': '2012-12-31', 'CF_NCF_OPERACT': '137,702,000.00', 'CF_INT_REC': '14,018,000.00', 'CF_INT_PAID': '-5,397,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-212,636,000.00', 'CF_FIN_ACT': '20,000,000.00', 'CF_BEG': '66,546,000.00', 'CF_CHANGE_CSH': '-46,313,000.00', 'CF_END': '20,364,000.00', 'CF_EXCH': '131,000.00'}, {'YEAREND_DATE': '2012-06-30', 'CF_NCF_OPERACT': '-57,049,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-314,000.00', 'CF_FIN_ACT': '14,206,000.00', 'CF_BEG': '83,546,000.00', 'CF_CHANGE_CSH': '-43,157,000.00', 'CF_END': '40,284,000.00', 'CF_EXCH': '-105,000.00'}, {'YEAREND_DATE': '2011-12-31', 'CF_NCF_OPERACT': '-32,555,000.00', 'CF_INT_REC': '9,444,000.00', 'CF_INT_PAID': '-2,996,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-162,029,000.00', 'CF_FIN_ACT': '-19,226,000.00', 'CF_BEG': '276,802,000.00', 'CF_CHANGE_CSH': '-207,362,000.00', 'CF_END': '66,546,000.00', 'CF_EXCH': '-2,894,000.00'}, {'YEAREND_DATE': '2011-06-30', 'CF_NCF_OPERACT': '-43,601,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-95,436,000.00', 'CF_FIN_ACT': '5,187,000.00', 'CF_BEG': '276,802,000.00', 'CF_CHANGE_CSH': '-133,850,000.00', 'CF_END': '137,777,000.00', 'CF_EXCH': '-5,175,000.00'}, {'YEAREND_DATE': '2010-12-31', 'CF_NCF_OPERACT': '-32,262,000.00', 'CF_INT_REC': '114,000.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-63,284,000.00', 'CF_FIN_ACT': '145,680,000.00', 'CF_BEG': '229,974,000.00', 'CF_CHANGE_CSH': '50,248,000.00', 'CF_END': '276,802,000.00', 'CF_EXCH': '-3,420,000.00'}, {'YEAREND_DATE': '2010-06-30', 'CF_NCF_OPERACT': '-6,756,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-31,115,000.00', 'CF_FIN_ACT': '34,127,000.00', 'CF_BEG': '229,974,000.00', 'CF_CHANGE_CSH': '-3,744,000.00', 'CF_END': '222,608,000.00', 'CF_EXCH': '-3,622,000.00'}, {'YEAREND_DATE': '2009-12-31', 'CF_NCF_OPERACT': '-8,974,000.00', 'CF_INT_REC': '135,000.00', 'CF_INT_PAID': '-51,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '-3,784,000.00', 'CF_INV': '-58,993,000.00', 'CF_FIN_ACT': '23,419,000.00', 'CF_BEG': '278,403,000.00', 'CF_CHANGE_CSH': '-48,248,000.00', 'CF_END': '229,974,000.00', 'CF_EXCH': '-181,000.00'}, {'YEAREND_DATE': '2009-06-30', 'CF_NCF_OPERACT': '2,674,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-4,088,000.00', 'CF_FIN_ACT': '-9,563,000.00', 'CF_BEG': '278,403,000.00', 'CF_CHANGE_CSH': '-10,977,000.00', 'CF_END': '268,583,000.00', 'CF_EXCH': '1,157,000.00'}, {'YEAREND_DATE': '2008-12-31', 'CF_NCF_OPERACT': '123,059,000.00', 'CF_INT_REC': '705,000.00', 'CF_INT_PAID': '-311,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '-12,669,000.00', 'CF_INV': '-83,789,000.00', 'CF_FIN_ACT': '140,000.00', 'CF_BEG': '253,152,000.00', 'CF_CHANGE_CSH': '27,135,000.00', 'CF_END': '278,403,000.00', 'CF_EXCH': '-1,884,000.00'}, {'YEAREND_DATE': '2008-06-30', 'CF_NCF_OPERACT': '76,780,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-48,464,000.00', 'CF_FIN_ACT': '-14,977,000.00', 'CF_BEG': '253,152,000.00', 'CF_CHANGE_CSH': '13,339,000.00', 'CF_END': '265,894,000.00', 'CF_EXCH': '-597,000.00'}, {'YEAREND_DATE': '2007-12-31', 'CF_NCF_OPERACT': '52,935,000.00', 'CF_INT_REC': '1,143,000.00', 'CF_INT_PAID': '-1,177,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '-15,374,000.00', 'CF_INV': '-121,753,000.00', 'CF_FIN_ACT': '172,888,000.00', 'CF_BEG': '165,718,000.00', 'CF_CHANGE_CSH': '88,662,000.00', 'CF_END': '253,152,000.00', 'CF_EXCH': '-1,228,000.00'}, {'YEAREND_DATE': '2007-06-30', 'CF_NCF_OPERACT': '-3,131,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-12,845,000.00', 'CF_FIN_ACT': '178,479,000.00', 'CF_BEG': '165,718,000.00', 'CF_CHANGE_CSH': '162,503,000.00', 'CF_END': '320,734,000.00', 'CF_EXCH': '-7,487,000.00'}, {'YEAREND_DATE': '2006-12-31', 'CF_NCF_OPERACT': '54,656,000.00', 'CF_INT_REC': '877,000.00', 'CF_INT_PAID': '-1,202,000.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '-17,303,000.00', 'CF_INV': '-18,131,000.00', 'CF_FIN_ACT': '5,885,000.00', 'CF_BEG': '140,220,000.00', 'CF_CHANGE_CSH': '24,782,000.00', 'CF_END': '165,718,000.00', 'CF_EXCH': '716,000.00'}, {'YEAREND_DATE': '2006-06-30', 'CF_NCF_OPERACT': '49,739,000.00', 'CF_INT_REC': '0.00', 'CF_INT_PAID': '0.00', 'CF_DIV_REC': '0.00', 'CF_DIV_PAID': '0.00', 'CF_INV': '-5,213,000.00', 'CF_FIN_ACT': '-6,925,000.00', 'CF_BEG': '140,220,000.00', 'CF_CHANGE_CSH': '37,601,000.00', 'CF_END': '177,781,000.00', 'CF_EXCH': '-40,000.00'}]

  中国智能集团:(00395)财务数据下载完成！
  
table_name_list ['主要财务指标 ', '利润表', '资产负债表', '现金流量表 ']
table_date_list [['2016-12-31', '2016-06-30', '2015-12-31', '2015-06-30', '2014-12-31', '2014-06-30', '2013-12-31', '2013-06-30', '2012-12-31', '2012-06-30', '2011-12-31', '2011-06-30', '2010-12-31', '2010-06-30', '2009-12-31', '2009-06-30', '2008-12-31', '2008-06-30', '2007-12-31', '2007-06-30', '2006-12-31', '2006-06-30'], ['2016-12-31', '2016-06-30', '2015-12-31', '2015-06-30', '2014-12-31', '2014-06-30', '2013-12-31', '2013-06-30', '2012-12-31', '2012-06-30', '2011-12-31', '2011-06-30', '2010-12-31', '2010-06-30', '2009-12-31', '2009-06-30', '2008-12-31', '2008-06-30', '2007-12-31', '2007-06-30', '2006-12-31', '2006-06-30'], ['2016-12-31', '2016-06-30', '2015-12-31', '2015-06-30', '2014-12-31', '2014-06-30', '2013-12-31', '2013-06-30', '2012-12-31', '2012-06-30', '2011-12-31', '2011-06-30', '2010-12-31', '2010-06-30', '2009-12-31', '2009-06-30', '2008-12-31', '2008-06-30', '2007-12-31', '2007-06-30', '2006-12-31', '2006-06-30'], ['2016-12-31', '2016-06-30', '2015-12-31', '2015-06-30', '2014-12-31', '2014-06-30', '2013-12-31', '2013-06-30', '2012-12-31', '2012-06-30', '2011-12-31', '2011-06-30', '2010-12-31', '2010-06-30', '2009-12-31', '2009-06-30', '2008-12-31', '2008-06-30', '2007-12-31', '2007-06-30', '2006-12-31', '2006-06-30']]
url_list ['cwzb', 'lrb', 'fzb', 'llb']

	'''